package com.to8to.autotask.sendmsg;

import java.util.ArrayList;
import java.util.List;

import com.to8to.msgcenter.thrift.TTarget;

public class MsgConstants {
	public static final String MSG_2_11 = "亲爱的，土巴兔装修网愿您春节回家一路平安！15年我们为您装修出谋划策，继续为您提供免费方案报价、装修保险、第三方监理等服务。退订回T";
	public static final String MSG_2_16 = "亲爱的，土巴兔装修网提前给您拜年送祝福了。祝新的一年万事如意，阖家欢喜。关注微信：土巴兔装修家居，为您解答所有装修疑问。退订回T";
	public static final String MSG_2_24 = "亲爱的，春节假期过将迎来装修旺季，想获得更多装修优惠，避免更多装修陷阱？快关注微信：土巴兔装修家居，为您解答所有装修疑问。退订回T";
	public static final String MSG_3_1 = "亲爱的，假期后上班状态差？安排量房让装修来调整你的状态吧！土巴兔装修网全体员工已动起来为您提供全程免费服务，亲快来吧。退订回T";

	/** 1.12月15号后发布，当前属于非结束状态且分配公司大于0的已售项目(有延期时间） */
	public static final String SQL_HAS_DELAYTIME = "SELECT ya.phone FROM to8to_yuyue_apply ya LEFT JOIN to8to_yuyue_apply_ext yae ON ya.yid=yae.yid WHERE ya.ispass=1 AND ya.delaytime >0 AND ya.puttime > 1418572800 AND yae.isassign=1 AND  yae.struid <>'' AND ya.cityid IN (523,1672,2827,1121,591,1547,2929,2920,1695,118,762,317,612,2912,2298,2013,1891,1,511,1681,2962,1181,2951,2933,523,1196,1440,1254,410,2619,1172,1422,2092,2836,2878,3094,974,2930,869,535,2855,558,1134,2116,2271,1783,605,571,1130) order by ya.yid";

	/** 2.12月15号后发布，分配公司为0的已售项目 */
	public static final String SQL_SELLED = "SELECT ya.phone FROM to8to_yuyue_apply ya LEFT JOIN to8to_yuyue_apply_ext yae ON ya.yid=yae.yid WHERE ya.ispass=1 AND ya.puttime > 1418572800 AND yae.isassign=1 AND  yae.struid ='' AND ya.cityid IN (523,1672,2827,1121,591,1547,2929,2920,1695,118,762,317,612,2912,2298,2013,1891,1,511,1681,2962,1181,2951,2933,523,1196,1440,1254,410,2619,1172,1422,2092,2836,2878,3094,974,2930,869,535,2855,558,1134,2116,2271,1783,605,571,1130) order by ya.yid";

	/** 3.延期时间在12月15号00：00-3月16号00：00的延期可售项目 */
	public static final String SQL_CANSELL = "SELECT phone FROM to8to_yuyue_apply WHERE ispass=2 AND delaytime >1418572800 AND delaytime<1426435200 AND uptime>1404144000 AND cityid IN (523,1672,2827,1121,591,1547,2929,2920,1695,118,762,317,612,2912,2298,2013,1891,1,511,1681,2962,1181,2951,2933,523,1196,1440,1254,410,2619,1172,1422,2092,2836,2878,3094,974,2930,869,535,2855,558,1134,2116,2271,1783,605,571,1130) order by yid";

	public static final int BATCH_SEND_SIZE = 2000;

	public static final String TESTPHONE_ZWH = "13537845140";

	public static final String TESTPHONE_ZLW = "18665982789";

	public static final String TESTPHONE_SEVEN = "13691992677";

	public static final String TESTPHONE_KUI = "15813718891";

	/** 移动 */
	public static final String TEST_PHONE_1 = "18820921191";
	/** 电信 */
	public static final String TEST_PHONE_2 = "18126281537";
	/** 联通 */
	public static final String TEST_PHONE_3 = "15544444358";

	public static List<TTarget> getTestPhone() {
		List<TTarget> testPhones = new ArrayList<TTarget>();
		TTarget test_zwh = new TTarget(null, TESTPHONE_ZWH, 0, 1);
		testPhones.add(test_zwh);

		TTarget test_zlw = new TTarget(null, TESTPHONE_ZLW, 0, 1);
		testPhones.add(test_zlw);

		TTarget test_seven = new TTarget(null, TESTPHONE_SEVEN, 0, 1);
		testPhones.add(test_seven);

		TTarget test_kui = new TTarget(null, TESTPHONE_KUI, 0, 1);
		testPhones.add(test_kui);

		// TTarget test_phone_1 = new TTarget(null, TEST_PHONE_1, 0, 1);
		// testPhones.add(test_phone_1);
		// TTarget test_phone_2 = new TTarget(null, TEST_PHONE_2, 0, 1);
		// testPhones.add(test_phone_2);
		// TTarget test_phone_3 = new TTarget(null, TEST_PHONE_3, 0, 1);
		// testPhones.add(test_phone_3);

		return testPhones;
	}
}
